OfficeHelp - Office Tutorials & Software Solutions
Search:
 
Advanced Search

 
Get FREE PC TIPS every month:

More Information Here

Most Popular

What's available for:
Calendars
Privacy & Security
Excel
Outlook
Word
PowerPoint
Internet Explorer
Others


Organization Chart Maker for Microsoft® Excel®

Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.


Other Contents
Design Chart Templates for Microsoft® Excel®
Automatically update hundreds of PowerPoint slides from Excel in minutes
Easily make your own home and office calendars for Microsoft® Excel®!
Calendar Templates with Holidays (USA / UK / Australia / Canada) for Excel
Make stylish Planner Calendars - CUSTOM Version
All CALENDARS at once!
Calendar Templates 2007 with Holidays for Excel
Make stylish Planner Calendars - ADVANCED Version
All TEMPLATES at once!
Make stylish Planner Calendars
Make stylish Planner Calendars - BASIC Version
Calendar Plan - Year Planner Template
How long the wait?

How to Buy
How safe it is to buy
Privacy Policy
Contact Us

RSS Feed OfficeHelp.Biz RSS Feed
Home Calendars Bundles Macros PC Tips Templates Newsletter Contact Us

Specializing in Advanced Spreadsheet & Office Macro Solutions.


Content Type Application Author Price
PC Tip Microsoft® Office® General OfficeHelp Free

How to manage Macro security in Microsoft®Office - Version 1.00

Tested on Microsoft® Office® General Versions: 2000 (9.0), XP (10.0), 2003 (11.0) - should work on any version from Office 97


 


Macros are software applications that run inside other applications, like Office packages. In fact, many commercial software's now include some form of end-user programming to allow for customization and automations of common tasks. Microsoft's VBA (Visual Basic for Applications) is the macro language bundled into Office and currently licensed to many other software makers.

They are very useful to extend the usefulness and productivity of the Office applications. As an example, in this website you can find, among others, Macros that build calendar plans using Excel and no extra software. You can do them manually but it will be a lot of work, specially if you have to update them or make new ones regularly. This wouldn't be possible

Click here to check the full list of Macros available on this website.

Using Office 2007?

Specific instructions below. Click here to jump to it.

Using Office 2010?

Specific instructions below. Click here to jump to it.

This article addresses all versions from Microsoft® Office 97 to Microsoft® Office 2010.

Are Macros dangerous? 

Macros are potentially dangerous. Since they are software and run by the PC user, they can do almost anything on the computer they're running, including erasing the hard drive and other forms of damage. And since they are imbedded in office applications, they can be mailed as regular office files. In fact, one of the first virus to use email to spread was the Melissa Virus, a Word Macro! Of course, back in 1999, email virus were just starting and nobody expected them, so email was considered safe and no defenses were in place.

Microsoft included some defenses into Office applications, like allowing users to request being questioned before running Office files with Macros. But since many users allow anything requested to them, the security measures become tougher and tougher every Office version:

  • Office 97 - Macros enabled by default without any warning, user could activate a warning message and decide what to do when opening files with Macros;
  • Office 2000 - Macros warning enabled by default, users would have to grant/deny permission to run every time they opened a file with Macros. Later updates to Office 2000, like the SP3 (Service Pack3), enforce security settings like the ones on Office XP;
  • Office XP and Office 2003 - Macros are completely disabled by default, unless the macro file is signed by its Author. In this case, the user can decide (on the warning message) to run or cancel the Macro. On a more permanent basis, the user can change the macro security settings to allow the running of unsigned Macros, with or without warning. 
  • Office 2007 - Files with macros will always open but with macros disabled. You can enable the macros to run after the file is loaded.

Given that most users have one of the 3 latest versions of Office, and macros don't run by default on them (at least without a warning), Office macros aren't currently the preferred platform for virus. But the latent danger remains.

What can you do to enable the running of Macros?

If macros are disabled, opening a file with a Macro will give no warnings until you try to use any functionality that required the macro, when a message such as this will be shown:

Macro Disabled Warning

If you have any need to run Macros and find that they are disabled, you can activate them following some easy steps. Never change the Macro security level to "Low", as it will enable the Macros to run without any warning. Change it to "Medium", where each time you open an Office file with a Macro, you will be prompted to allow its execution.

This steps have been recorded using an Office 2000 version of Excel, but should be valid to all office applications and versions from Office 2000, aesthetics apart. So even if it looks a bit different, the mentioned menus and dialog boxes should be there (if not press here) .

1) On the "Tools" menu, select the "Security" entry of the "Macros" submenu:

Macros location on the Tools menu

 

2) To run unsigned macros under specific permission, like the ones currently provided by www.officehelp.biz, select the Medium option. You will be prompted every time you run a file with a macro for permission toe execute the macro. The default (High) will only run signed Macros, that some providers supply, and only after permission. Never choose the "low" option. Press OK to save.

Macro security levels

3) When you try to execute a macro on a "Medium" security level (or signed Macro on  the "High" security level) you are prompted with the permission to run the Macro. Click the "Enable Macros" button to 

Macro execution prompt

What if the menus or options are not there?

If you can't find the mentioned menu entries on your Office 2000 / XP / 2003 then it is possible that the Office Macros functionality is not installed. Get the Office installation CD and install the missing components. If you're using Office 97, the activation of the Macro security options was on the "Options" entry of the "Tools" menu.

Office 2007 - Specific Instructions

Office 2007 has a completely new interface, based on the new "Ribbon" instead of the classic Menu / Toolbar set. The handling of macro security is also different and based on a different principle. Files with macros will always open but with macros disabled. You can enable the macros to run after the file is loaded.

1) Open the file with the macros. The file will open normally and no warning messages will be given, but macros will not work. Below the Ribbon, there is a discrete warning message and a button:

Office 2007 Warning Message and Button

2) Click the "Options" button and a pop-up windows will be shown. Select "Enable this content" and click "OK" to enable the macros.

Office 2007 - Macro Activation Pop-Up

3) Use the macro. There is NO NEED to close and reopen the file.

Office 2010 Single Click Macro Activation - Specific Instructions

Office 2010 interface is similar to Excel 2007 but there is a difference in the way macros are enabled, with a single click needed. Files with macros will always open but with macros disabled. You can enable the macros to run after the file is loaded.

1) Open the file with the macros. The file will open normally and no warning messages will be given, but macros will not work. Below the Ribbon, there is a discrete warning message and a button:

Office 2010 Warning Message and Button

2) Click the "Enable Content" button to enable the macros with a single click. Macros will be enabled and the warning message will disappear:

Office 2010 - Single-Click Macro Activation

3) Use the macro. There is NO NEED to close and reopen the file.

 

Notes for Corporate Users

The configuration of the Office applications installed on corporate computers is usually defined centrally by the IT team: users may or not be allowed to change them. If the configuration is locked, you won't be able to change it because the options don't work or are not available on the menus. If this is your case, you do need to contact your IT support staff to enable Macros on your system. They will probably demand a valid working reason to do so and may want to try and test the Macros you intend to run.

Macros supplied by OfficeHelp.Biz are all safe and can be checked by the IT department for safety before being used on any computer.

Can I get extra information on this subject?

The Help file on any of the Office applications should have detailed information on Macros. Open help (using the Help menu or pressing the F1 key) and search for Macro, as on the following picture.

Help on Macros



Get FREE PC TIPS every month:

 

How to manage Macro security in Microsoft®Office - Version 1.00

Tested on Microsoft® Office® General Versions: 2000 (9.0), XP (10.0), 2003 (11.0) - should work on any version from Office 97


Back
Other Contents  

00052- Design Chart Templates for Microsoft® Excel® Microsoft Excel Templates
The easiest way to create design charts. Check the samples, enter your own data and watch as your charts update. Multiple different charts from the same data, with many automatic calculations made for you. No code, macros, formulas or other complicated stuff. Just fill in YOUR data and watch the charts update automatically.
 
00054- Automatic Copy/Paste for Microsoft PowerPoint® Microsoft Excel Macro
Automatically update hundreds of Microsoft PowerPoint® slides, charts and tables from Excel in minutes. With the click on a button. Easily configure the updates you need. Copy from multiple Excel files. Resize and place pasted charts & tables – or just keep their original size & position.
 
00051- Organization Chart Maker for Microsoft® Excel® Microsoft Excel Macro
Quickly and easily generate your own organization charts from a plain list of data with Organization Chart Maker for Microsoft® Excel®. Apply colors and formats. Integrate external data from ERP or HR management systems like or Microsoft® Dynamics Navision, SAP®, PeopleSoft®, Oracle®, etc. Chart Stock & Portfolio listings, team members planning & company ownership charts.
 
00037- Traditional Calendars for Excel Microsoft Excel Macro
Easily generate annual and monthly Traditional & Planning calendars you can print and distribute, based only in Microsoft® Excel®. Five different formats available. Use special colors for special days or events, like holidays or meetings. Automatic event legend. Configurable background and font colors. Optional calendar background image. Traditional, Academic and Fiscal years. Imports data from Microsoft ® Outlook®.
 
00047- Calendar Templates 2014 with Holidays (USA / UK / Australia / Canada) for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for Microsoft® Excel®. Includes versions with Holidays for the USA, UK, Australia and Canada.
 
00044- Custom GANTT Charts for Microsoft® Excel® Microsoft Excel Macro
Generate CUSTOM Project style calendar plans with the EXCLUSIVE option to customize our COPYRIGHT messages to create YOUR own REBRANDED Edition. Includes all ADVANCED Edition features plus the REBRANDING option. Distribute CORPORATE versions to your staff.
 
00027- Get all OfficeHelp.Biz CALENDARS at once! Microsoft Excel Bundles
Interested in more than one of our Microsoft® Excel® Calendars? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00046- Calendar Templates 2007 with Holidays for Excel Microsoft Excel Templates
Yearly, Monthly and Weekly Calendar templates (2 each) for 2007 in Excel. Include USA Holidays.
 
00002- Calendar Plan Generator - ADVANCED Edition Microsoft Excel Macro
Generate ADVANCED Project style calendar plans, just by entering the tasks and associated data like its name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel® file. Includes ADVANCED features like EXTRA plan types, detail filtering, optional fields, extra information of task bars, full customization and Microsoft® Outlook® integration.
 
00040- Get all OfficeHelp.Biz TEMPLATES at once! Microsoft Excel Bundles
Interested in more than one of our Templates, including all Excel Calendar Templates? Don't want the hassle of paying per purchase? Want to SAVE TIME AND MONEY?
 
00036- Calendar Plan Generator - Source Code Edition Microsoft Excel Macro
Generate Project style calendar plans (weekly only), just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. SOURCE CODE available for changes for VBA Macro developers.
 
00043- Calendar Plan Generator - BASIC Edition Microsoft Excel Macro
Easily generate Project style calendar plans, just by entering the tasks and associated data like it's name and the starting and end date. Use different colors and select a deadline terminator for each task. Indent each task to its level or sub-level. Change, save and email the resulting calendar as any other regular Microsoft® Excel file. The SIMPLEST edition, just ONE button to use!
 
00028- Calendar Plan - Year Planner Template Microsoft Excel Templates
Create pretty yearlong planning calendars in minutes. Save time and effort. Ready to use calendar template! Really useful to set yearlong event like general meetings, special groups, holidays and all other long-term schedules. Regular Excel file, sample included.
 
00001- Queue Servicing Calculator Microsoft Excel Macro
Calculates the average waiting times and people (or item) processing times based on some input estimates. Can be used to make service capacity simulations or to measure the service throughput on any service or process demanding waiting queues.
 

Privacy Policy How to Buy How safe is it to Buy? RSS Feed Contact Us

(c) 2004 - 2024 OfficeHelp.Biz